Cash Flow Sensitivity Analysis
Use this template to prepare a cash flow sensitivity analysis. Prepare your expected cash flow projections and by entering a percentage change assumption, the template will automatically prepare a pessimistic and optimistic set of cash flow scenarios. Under the pessimistic scenario, cash receipts will be lowered by the percentage and disbursements will be increased by the same percentage. Under the optimistic scenario, receipts will be increased while disbursements will be decreased by the percentage assumption. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Cash Flow Sensitivity Analysis
<- Enter date in cell to the left
<- Enter period covered by report in cell to the left
% change in receipts and disbursements Expected Beginning Cash Balance Cash Inflows (Income): Accounts Receivable Collections Loan Proceeds Sales & Receipts Other: Pessimistic Optimistic
Total Cash Inflows Available Cash Balance Cash Outflows (Expenses): Advertising Bank Service Charges Contingencies Credit Card Fees Delivery Charges Deposits Dues & Subscriptions Health Insurance Insurance Interest Inventory Purchases Lease Payments Licenses & Permits Miscellaneous Office Payroll Payroll Taxes Professional Fees Rent or Lease Repairs & Maintenance Sales tax Services Signs Supplies Taxes & Licenses Utilities & Telephone Other:
Subtotal Other Cash Out Flows: Capital Purchases Building Construction Decorating Fixtures & Equipment Install Fixtures & Equip. Remodeling Lease Payments Loan Principal Owner's Draw Other: Subtotal Total Cash Outflows Ending Cash Balance